Thread: Age Date Between Two Dates to Return Value as 30, 60, 90 day
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
  
Posts: 915
Default Age Date Between Two Dates to Return Value as 30, 60, 90 day
Nath wrote:
Hi,

How do I calculated between two dates to return the value as 30, 60, 90 day.

One way:

=CEILING(day2 - day1,30)

Substitute day2 and day1 with references to your actual dates.
Reply With QuoteReply With Quote