• 410K Members
• 7,517 Online
• 466K Conversations

## Modifying formula based on Date and time

Occasional Contributor

# Modifying formula based on Date and time

Dear All,
Please modify  the highlighted bold formula that gives the result in such a way.

=SUM(COUNTIFS(RM!\$F:\$F,\$D25,RM!\$H:\$H,{"COMP","CLOSE","WCLOSE"},RM!\$I:\$I,">="&DATE(2018,12,1),RM!\$I:\$I,"<="&EOMONTH(DATE(2018,12,1),0)))

1. RM!\$I:\$I,">="&DATE(2018,12,1)  It will calculate based on 1dec 2018 time 00:59:59.000 am (hh:mm:ss.mmm)
2.
RM!\$I:\$I,"<="&EOMONTH(DATE(2018,12,1) It will calculate based on 31dec 2018 time 23:59:59.000 pm

Thanks

Regards,
aligahk06

# Re: Modifying formula based on Date and time

Hi Abdul,

You may add TIME to calculations like

```(DATE(2018,12,1)+TIME(0,59,59))

(EOMONTH(DATE(2018,12,1),0)+TIME(23,59,59))
```

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies