{"id":1313,"date":"2020-06-28T11:38:02","date_gmt":"2020-06-28T03:38:02","guid":{"rendered":"http:\/\/www.fyndpro.com\/?p=1313"},"modified":"2026-08-27T16:15:01","modified_gmt":"2026-08-27T08:15:01","slug":"10dateformulas","status":"publish","type":"post","link":"https:\/\/www.fyndpro.com\/en\/10dateformulas\/","title":{"rendered":"10 Super-Useful Excel Date Functions at a Glance"},"content":{"rendered":"

\"\"<\/p>\n

Assume A2 is the cell containing the date; A5 through A6 are the cells containing holidays.<\/p>\n

    \n
  1. Calculate age from birthdate: =DATEDIF(A2,TODAY(),\u201dy\u201d)&\u201d\u6b72\u201d<\/li>\n
  2. Determine the weekday for a date: =TEXT(A2,\u201daaaa\u201d)<\/li>\n
  3. Number of days in the month of a given date: =DAY(EOMONTH(A2,0))<\/li>\n
  4. Find the next working day: =WORKDAY(A2,1,A5:A6)<\/li>\n
  5. Determine whether a date is in the early\/mid\/late part of the month: =LOOKUP(DAY(A2),{0,11,21},{\"Early\",\"Mid\",\"Late\"})<\/li>\n
  6. Convert a date to \u201c20001006\u201d format: =TEXT(A2,\"emmdd\")<\/li>\n
  7. Determine the quarter for a given date: =LEN(2^MONTH(A2))<\/li>\n
  8. Count how many Mondays there were in 2000: =NETWORKDAYS.INTL(\"2000-1-1\",\"2000-12-31\",\"0111111\")<\/li>\n
  9. Get the current time (hours and minutes): =NOW()-TODAY()<\/li>\n
  10. Determine whether this year is a leap year: =IF(COUNT(-\"2-29\"),\"Yes\",\"No\")<\/li>\n<\/ol>","protected":false},"excerpt":{"rendered":"

    \u5047\u8a2dA2\u662f\u5b58\u653e\u65e5\u671f\u7684\u5132\u5b58\u683c\uff1bA5\u81f3A6\u662f\u5b58\u653e\u5047\u671f\u7684\u5132\u5b58\u683c \u6839\u64da\u51fa\u751f\u5e74\u6708\u8a08\u7b97\u5e74\u9f61\uff1a=DATEDIF(A2,TOD […]<\/p>\n","protected":false},"author":1,"featured_media":3787,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[8,20],"tags":[170,161,163,164,27,157,92,166,167,168,162,169,165,286],"class_list":["post-1313","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-onlinesupport","tag-count","tag-datedif","tag-day","tag-eomonth","tag-if","tag-len","tag-lookup","tag-month","tag-networkdays-intl","tag-now","tag-text","tag-today","tag-workday","tag-date-calculation"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2026\/08\/new_covers_batch_02_474_excel.jpg?fit=816%2C1088&ssl=1","_links":{"self":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/comments?post=1313"}],"version-history":[{"count":2,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1313\/revisions"}],"predecessor-version":[{"id":1316,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1313\/revisions\/1316"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/media\/3787"}],"wp:attachment":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/media?parent=1313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/categories?post=1313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/tags?post=1313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}