writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 19:
Line 19: − + + + + + + + + + + + + + + + + + + + + +
→Examples
==Examples==
==Examples==
#=EDATE("1/1/1910",2) = Tue Mar 01 1910 00:00:00 GMT +0530 (Indian standard time)
#=EDATE("1/1/1910",2) = 03/01/1910
#=EDATE("5/4/1897",5) = Mon Tue 04 1897 00:00:00 GMT +0530 (Indian standard time)
#=EDATE("5/4/1897",5) = Mon Tue 04 1897 00:00:00 GMT +0530 (Indian standard time)
#=EDATE("11/31/1999",3) = Wed Mar 01 2000 00:00:00 GMT +0530 (Indian standard time)
#=EDATE("11/31/1999",3) = Wed Mar 01 2000 00:00:00 GMT +0530 (Indian standard time)
#=EDATE("6/6/1979",-2) = Fri Apr 06 1979 00:00:00 GMT +0530 (Indian standard time)
#=EDATE("6/6/1979",-2) = Fri Apr 06 1979 00:00:00 GMT +0530 (Indian standard time)
#=EDATE("4/15/1950",-6) = Sat Oct 15 1949 00:00:00 GMT +0530 (Indian standard time)
#=EDATE("4/15/1950",-6) = Sat Oct 15 1949 00:00:00 GMT +0530 (Indian standard time)
#EDATE(TODAY()) = 02/23/2022
#EDATE(TODAY(),2.5) = 05/08/2022
#EDATE(TODAY(), 2,"week") = 03/09/2022
#EDATE(TODAY(), 2.5,"week") = 03/12/2022
#EDATE(TODAY(), -13.5,"week") = 11/20/2021
#EDATE(NOW(),1,"week") = 03/02/2022
#EDATE(NOW(),1..5,"quarter")
{| class="wikitable"|-
!!start_date !! months!! otherperiodtag!! EDATE
|-
| Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) || 1 || quarter || 05/23/2022
|-
| Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) || 2 ||quarter|| 08/23/2022
|-
| Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) || 3 || quarter || 11/23/2022
|-
| Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) || 4 || quarter || 02/23/2023
|-
| Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) || 5 || quarter || 05/23/2023
|}
==Related Videos==
==Related Videos==