How to put the date in MMM-yy format but inside it should be end of the current month

Help Automation Ops
,
1

How to put the date in MMM-yy format but inside it should be end of the current month

image
image202×277 2.61 KB

like above mentioned screenshot

2

@anjani_priya

Thats a formatting option. Use format cells activity and give the format you need..so that the value remains as is but the format changes to MMM-yy

Format cells is an activity in excel activities

Cheers

3

@Anil_G
But in format cells there 2 only 2 options

image
image325×304 7.8 KB

4

@anjani_priya

Use custom and give the format you need

Cheers

1 Like
5

Thankyou for the solution

1 Like
6

@Anil_G
The cell has colours and font, the format is missing after I use format cells

image
image384×109 2.02 KB

7

@anjani_priya

You can include the color and font as well in format cell

Font and fill are what you need to use

Cheers

8

I couldn’t find the exact colour which is in excel

9

@anjani_priya

Use get cell color and set cell color

Cheers

10

Thankyou @Anil_G I will try

11

There is no set cell colour activity

12

@anjani_priya

Cheers

1 Like
13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.