If then formula with date
Closed
Jyoungblood
Posts
1
Registration date
Thursday 18 June 2015
Status
Member
Last seen
18 June 2015
-
18 Jun 2015 à 09:55
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 23 Jun 2015 à 10:59
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 23 Jun 2015 à 10:59
Related:
- If then formula with date
- Logitech formula vibration feedback wheel - Download - Drivers
- Spreadsheet formula - Guide
- Grade formula in excel marksheet - Guide
- Formula bar in excel - Guide
- Date formula in excel dd/mm/yyyy - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
22 Jun 2015 à 11:05
22 Jun 2015 à 11:05
Hi Jyoungblood,
How would Excel know what the next due date is?
Formula in A6 would be something like:
=IF(C5<>"","Next due date","")
Best regards,
Trowa
How would Excel know what the next due date is?
Formula in A6 would be something like:
=IF(C5<>"","Next due date","")
Best regards,
Trowa
Still not quite there. If c5 is blank, I want a6 to remain blank. If c5 has a date in it, I want a6 to add 3 days to c5 and then place that date in a6. Thanks
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
23 Jun 2015 à 10:59
23 Jun 2015 à 10:59
Hi Jyoungblood,
Of course we are not there yet! Because you didn't provide all the info. I can't read minds you know!
Formula in A6 will now be:
=IF(C5<>"",C5+3,"")
Best regards,
Trowa
Of course we are not there yet! Because you didn't provide all the info. I can't read minds you know!
Formula in A6 will now be:
=IF(C5<>"",C5+3,"")
Best regards,
Trowa
